package com.ls.data.mapper;

import com.ls.pojo.CustInter;
import com.ls.pojo.InterThirdparty;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author 段成
 * @date 2020/1/9 - 13:35
 */
@Mapper
public interface CustomerInterfaceMapper {
    @Select("select appkey from tb_cust_inter where cust_id=#{cid} and inter_id=#{iid}")
    String getAppkeyByUidAndIid(@Param("iid") Integer iid,@Param("cid") Integer cid);

    @Select("select appkey from tb_cust_inter where appkey=#{appkey} and inter_id=#{id}")
    CustInter getAppkeyByAppkey(@Param("appkey") String appkey,@Param("id")  Integer id);
}
